﻿CREATE VIEW dbo.uvwLogCheckIntervalConfig
AS
SELECT        dbo.LogCheckIntervalConfig.Id AS LogCheckIntervalId, dbo.InstanceConfig.InstanceName, dbo.LogCheckIntervalConfig.LogType, dbo.LogCheckIntervalConfig.CheckInterval, 
                         dbo.LogCheckIntervalConfig.LastCheck, dbo.LogCheckIntervalConfig.LastModifiedDate
FROM            dbo.InstanceConfig INNER JOIN
                         dbo.LogCheckIntervalConfig ON dbo.InstanceConfig.Id = dbo.LogCheckIntervalConfig.InstanceConfigId